package com.example.qxfw.rcyw.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.qxfw.common.entity.yj.WarnMonitorInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.sql.Timestamp;
import java.util.List;

@Mapper
@DS("service")
public interface WarnMoniInfoMapper extends BaseMapper<WarnMonitorInfo> {
    /**
     * 获取气象信息
     * @param warningtime
     * @param systemname
     * @return
     */
    @Select("select stationid, systemname, county, warningtime, warningtype,isrevised, monitorvalue, time, id " +
            "from warn_moni_info " +
            "where isremoved=0 and warningtime >= '${warningtime}' and systemname = '${systemname}'")
    List<WarnMonitorInfo> selectWarnMoniInfo(Timestamp warningtime, String systemname);
}
